the sql server database engine automatically detects deadlock cycles within sql server sqlserver數(shù)據(jù)庫引擎自動檢測sqlserver中的死鎖循環(huán)。
represents the two or more sub-threads from the same spid that are involved in the deadlock cycle 表示死鎖循環(huán)中涉及的兩個或多個具有相同spid的子線程。
specifies the participating thread that sql server chooses as the victim to break the deadlock cycle 指定sqlserver選擇作為犧牲品來中斷死鎖循環(huán)的參與線程。
if sessions involved in the deadlock cycle have the same deadlock priority and the same cost, a victim is chosen randomly 如果死鎖循環(huán)中會話的死鎖優(yōu)先級和開銷都相同,則會隨機選擇死鎖犧牲品。
if a deadlock has just been detected, it is assumed that the next threads that must wait for a lock are entering the deadlock cycle 如果剛剛檢測到死鎖,則假定必須等待鎖的下一個線程正進入死鎖循環(huán)。